Model Table WORK CENTER
This model dimension represents work centers and is based on the IFS Cloud
view WORK_CENTER. There is no core dimension that supports this information.
All models that refers to this dimension will have the attributes and hierarchies
as described below.
Natural parent is contract, i.e. a contract has work centers.
Attributes
| Attribute |
Description (where applicable) |
| Department No | Department description based on CONTRACT and DEPARTMENT_NO |
| Site No | |
| Work Center | Built as WORK_CENTER_NO + ' - ' + DESCRIPTION |
| Work Center Description | Description of the work center (DESCRIPTION) |
| Work Center No | Work center number (WORK_CENTER_NO) |
| Hierarchy |
Level |
| WorkCenterHy | |
| Site No |
| Work Center |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| WORK CENTER | DIM_WORK_CENTER_TM | DIM_WORK_CENTER_BI | DIM_WORK_CENTER | On Line |